﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobj of eComProduct" >
	<Sql>
		SELECT
		id,partId,supplierPartId,supplierId,
		avgCostPrice,listPrice,sellPrice, sellPriceDescription,
		weight as weight_amount,weightUnit as weight_unit,
		width as dimensions_width_amount,widthUnit as dimensions_width_unit,
		length as dimensions_length_amount,lengthUnit as dimensions_length_unit,
		depth as dimensions_depth_amount,depthUnit as dimensions_depth_unit,
		pricingId, checkoutWizard
		FROM
		eComProducts
		WHERE
		partId = @partId and companyId = @companyId;
	</Sql>

	<Param name="partId" type="UnicodeVarChar"/>
	<Param name="companyId" type="UniqueIdentifier" />
</AdoNetDataAccess>